SaleReturnTaxOverrideModifier

Entity Definition

Logical Name : SaleReturnTaxOverrideModifier
Physical Name : TR_MDFR_SLS_TX_OVRD

A line item modifier to the SaleReturnTaxLineItem component of a RetailTransaction that provides supplementary data regarding tax overrides. (Where the amount of tax collected is reduced rather than exempted).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
SalesTaxSequenceNumber (FK)(PK) A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. IC_SLS_TX_SQN_NMB LineNumber smallint SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX)
TaxGroupRuleID (FK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer TaxGroupRule(RU_TX_GP)
TaxableAmount The monetary amount for which tax is applicable at the new rate. MO_TXBL MoneyShortRetail decimal(7,2)
OriginalTaxAmount The original amount of Tax that should've been collected but wasn't because of this TaxOverrideModifier. MO_TX_ORGL MoneyShortRetail decimal(7,2)
NewTaxAmount The new amount of Tax that is being collected because of this TaxOverrideModifier. MO_TX_NEW MoneyShortRetail decimal(7,2)
OriginalTaxPercent The original tax rate that should've been collected but wasn't because of this TaxOverrideModifier. PE_TX_ORG Percent decimal(7,4)
NewTaxPercent The new tax rate that is being collected because of this TaxOverrideModifier. PE_TX_NEW Percent decimal(7,4)
ReasonCode (FK) A retailer assigned reason code denoting why this TaxOverride is being granted. CD_RSN Code varchar(20) Reason(CO_CD_RSN)
CustomerOverrideID Identifier presented by Customer to get this tax override. Not used if Customer presents an individualised tax override certificate. ID_OVRD_CT IdentityAlphaNumeric varchar(20)
CertificateNumber A unique identifier taken from a TaxOverride certificate that was presented by the Customer in order to claim the TaxOverride. ID_CF_TX_OVRD IdentityAlphaNumeric varchar(20)
CertificateHolderName The name of the Customer taken from a TaxOverride certificate that was presented by the Customer in order to claim the TaxOverride. NM_CF_HLDR Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
TaxGroupRule originally applied to SaleReturnTaxOverrideModifier
SaleReturnTaxLineItem is overridden by SaleReturnTaxOverrideModifier
Reason classifies SaleReturnTaxOverrideModifier

Logical Views containing SaleReturnTaxOverrideModifier

Logical View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02315 - Retail Transaction - Customer Order
Logical 02320 - Retail Transaction - Taxation View
Logical 05000 - Taxation - Macro View
Logical 05200 - Taxation - Retail Transaction View